// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_MRP_QTY
// * CreateDate    : 2014-06-05 18:30:19
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:19
// * LastChanger   : 2014-06-05 18:30:19
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class ProdMrpQtyTable : TableInfo
    {
		public const string C_TableName = "PROD_MRP_QTY";
		
		public const string C_PRODUCT_ID = "PRODUCT_ID";
		public const string C_WAREHOUSE_CODE = "WAREHOUSE_CODE";
		public const string C_CURRENT_STORAGE_QTY = "CURRENT_STORAGE_QTY";
		public const string C_PLAN_PURCHASE_QTY = "PLAN_PURCHASE_QTY";
		public const string C_AVAILABLE_QTY = "AVAILABLE_QTY";
		
		public ProdMrpQtyTable()
        {
            _tableName = "PROD_MRP_QTY";
        }
		
		protected static ProdMrpQtyTable _current;
        public static ProdMrpQtyTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new ProdMrpQtyTable();

            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID,"ProductId", true, typeof(string)));
            _current.Add(C_WAREHOUSE_CODE, new ColumnInfo(C_WAREHOUSE_CODE,"WarehouseCode", false, typeof(string)));
            _current.Add(C_CURRENT_STORAGE_QTY, new ColumnInfo(C_CURRENT_STORAGE_QTY,"CurrentStorageQty", false, typeof(decimal)));
            _current.Add(C_PLAN_PURCHASE_QTY, new ColumnInfo(C_PLAN_PURCHASE_QTY,"PlanPurchaseQty", false, typeof(decimal)));
            _current.Add(C_AVAILABLE_QTY, new ColumnInfo(C_AVAILABLE_QTY,"AvailableQty", false, typeof(decimal)));
			
		}
		
		public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }
		
		public ColumnInfo WAREHOUSE_CODE
        {
            get { return this[C_WAREHOUSE_CODE]; }
        }
		
		public ColumnInfo CURRENT_STORAGE_QTY
        {
            get { return this[C_CURRENT_STORAGE_QTY]; }
        }
		
		public ColumnInfo PLAN_PURCHASE_QTY
        {
            get { return this[C_PLAN_PURCHASE_QTY]; }
        }
		
		public ColumnInfo AVAILABLE_QTY
        {
            get { return this[C_AVAILABLE_QTY]; }
        }
		
		
		
	}
}

